🕷️️ Job Radar • SCRAPING

freelancer.com 🟡 2026-05-02

🔹 [Target] Excel-Claude Integration [Method] Python Scripting [UI/UX] None [Stack] Python 3.x with requests, pandas, openpyxl [Security] Basic Error Logging [Format] Strict JSON Parsing
👤 Client: 🇮🇳 Patna, India Member since 2020-10-01
💰 Price: $9 / hr Average bid
🚩 Problem: Integrate company names from an Excel sheet into Claude AI API for contact discovery and export results back to Excel.
📦 Existing: Not specified

Specifications:

[Target] Define a Python script that reads company names from an Excel file, queries Claude AI through its API, processes the JSON response, and writes the data back to an Excel sheet.
[Method] Use Python 3.x with requests for API calls, pandas for handling Excel files, and openpyxl for writing results. Implement error logging and rate limiting to ensure reliability.
[UI/UX] No UI automation; focus on backend processing.
[Stack] Python 3.x, requests, pandas, openpyxl
[Security] Log errors and implement back-off delays to avoid triggering rate limits.
[Format] Parse JSON responses into a structured Excel format with each contact in its own row.

Workflow:

1. Read company names from an Excel sheet using pandas.
2. For each company name, make API calls to Claude AI through requests library.
3. Parse the JSON response and extract relevant fields (website, email, phone, title).
4. Write extracted data into a new Excel sheet row by row with openpyxl, ensuring each contact is in its own row for the same company.
5. Implement error handling to log issues and allow script resumption from the last processed row.